package com.hl.mapper;

import com.hl.domain.Consultproblem;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;

/**
* @author lihao
* @description 针对表【consultproblem(咨询问题表，存储用户提出的咨询问题)】的数据库操作Mapper
* @createDate 2024-09-05 21:39:58
* @Entity com.hl.domain.Consultproblem
*/
public interface ConsultproblemMapper {

    //根据id删除
    int deleteByPrimaryKey(Long id);

    int insert(Consultproblem record);

    int insertSelective(Consultproblem record);

    Consultproblem selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Consultproblem record);

    int updateByPrimaryKey(Consultproblem record);


    //查询问题和用户联表
    List<Consultproblem> selectAllByPageAndUser();

    //回复数
    Long selectAllreplys(Long id);

    //模糊查询
    List<Consultproblem> selectAllByLike(@Param("problemtitle") String problemtitle ,
                                         @Param("startTime")Date startTime,
                                         @Param("endTime")Date endTime);
}
